package com.pic.mgt.dao;

import java.util.Date;

import org.springframework.dao.DataAccessException;

public interface IBusinessMgtDao extends IBasicDao {
	
	// table 內共同的欄位名稱
	public static final String _confirmationFile = "confirmation_file";
	public static final String _targetFile = "target_file";
	public static final String _type = "type";
	public static final String _targetFilesize = "target_file_size";
	public static final String _status = "status";
	public static final String _unitName = "unit_name";
	public static final String _creatingTime = "creating_time";


	public String findStatusByUnitName(String unitName)
							throws DataAccessException;
	
	public int updateStatusByUnitName(String statusValue,
								      String unitName)
					 throws DataAccessException;
	
	public int updateCreatingTimeByUnitName(Date creatTime, String unitName) throws DataAccessException;
	
	public int updateStatusAndCreatingTimeByUnitName(String statusValue, Date creatingTime, String unitName) throws DataAccessException;
}
